package ylsb.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import ylsb.model.*;

public interface Hc45Mapper {
    int countByExample(Hc45Example example);

    int deleteByExample(Hc45Example example);

    int deleteByPrimaryKey(String id);

    int insert(Hc45 record);
    int insertBatch(List<Hc45> list);

    int insertSelective(Hc45 record);

    List<Hc45> selectByExample(Hc45Example example);

    Hc45 selectByPrimaryKey(String id);

    int updateByExampleSelective(@Param("record") Hc45 record, @Param("example") Hc45Example example);

    int updateByExample(@Param("record") Hc45 record, @Param("example") Hc45Example example);

    int updateByPrimaryKeySelective(Hc45 record);

    int updateByPrimaryKey(Hc45 record);

    List<Map<String, Object>> findPinzhongAll(@Param("xiangmuid") String ppxiangmuId);

    List<Map<String, Object>> findGuochanBypinzhong(@Param("xiangmuid") String ppxiangmuId,@Param("zongxuhao")String ppPinzhong);

    List<Map<String, Object>> findPinpaiList(@Param("xiangmuid") String ppxiangmuId,@Param("zongxuhao")int ppPinzhong);

    List<Map<String, Object>> findGuochanmuluBypinzhong(@Param("xiangmuid") String ppxiangmuId,@Param("zongxuhao")String ppPinzhong);

    List<Map<String, Object>> findGuochanPinzhong(@Param("xiangmuid") String ppxiangmuId);

    List<Map<String, Object>> findFengbi(@Param("xiangmuid") String ppxiangmuId);

    List<Map<String, Object>> findFengbiCount(@Param("xiangmuid") String ppxiangmuId,@Param("pinzhongxuhao")String ppPinzhong);

    List<Map<String, Object>> findResultBypinzhong(@Param("xiangmuid") String ppxiangmuId,@Param("userid")String ppuserId,@Param("zongxuhao")String ppPinzhong);

    List<Map<String, Object>> findResultGuochanBypinzhong(@Param("xiangmuid") String ppxiangmuId,@Param("userid")String ppuserId,@Param("zongxuhao")String ppPinzhong);

    Object getPinguiCount(@Param("xiangmuid") String mmxiangmuId);

    Object getPinzhongCount(@Param("xiangmuid") String mmxiangmuId);
    Object getPinpaiCount(@Param("xiangmuid") String mmxiangmuId);

    Object getPaichuPinguiCount(@Param("xiangmuid") String mmxiangmuId);
//
    List<Map<String, Object>> getCountByPinzhongAndPinpai(@Param("pinzhongxuhao") int mmpinzhong,
                                                          @Param("pinpai") String mmpinpai,
                                                          @Param("xiangmuid") String mmxiangmuId);

    List<Map<String, Object>> findXinghaoByPinpai(@Param("xiangmuid") String ppxiangmuId,@Param("zongxuhao")int ppPinzhongOne,@Param("pinpai")String ppPinpaiOne);

//    List<Map<String, Object>> findAllByXiangmuIdAndTiaojian(@Param("xiangmuid") String ppxiangmuId,@Param("leibie")String ppleibie,@Param("pinpaiqingkuang")String pppinpaiqingkuang);

    List<Map<String, Object>> findAllByXiangmuIdAndTiaojian(@Param("xiangmuid") String ppxiangmuId);

    List<Hc45pinzhong> selectAllByXiangmuid(@Param("xiangmuid") String xiangmuid, @Param("startindex") int startIndex,
                                             @Param("pagesize") int pageSize);

    List<Hc45pinzhong> selectBiaojueByXiangmuid(@Param("xiangmuid") String xiangmuid,
                                                @Param("userid") String userid,
                                                @Param("startindex") int startIndex,
                                                @Param("pagesize") int pageSize);

    Object getHc45list(@Param("xiangmuid") String ppxiangmuId,
//                        @Param("leibie") String mmleibie,
//                        @Param("pinpaiqingkuang") String mmpinpaiqingkuang,
                        @Param("startindex") int ppStartIndex, @Param("pagesize") int ppPageSize);

}